31 Microsoft 365 Usage
A practical course that treats Microsoft 365 usage not as simple Office app operation, but as a core digital work and learning skill connecting Outlook, OneDrive, Word, Excel, PowerPoint, Teams, OneNote, Forms, SharePoint, Planner, Power Automate, Power Apps, and Copilot for productivity, collaboration, data management, automation, and AI assistance.
0. Purpose and ultimate goal
The ultimate goal is to help learners connect email, calendar, documents, files, meetings, notes, forms, data, team sites, task boards, automation, and AI assistance into one work and learning system that improves individual and organizational execution. The course follows a professional training style centered on repeated Microsoft 365 practice, shared-document production, OneDrive and SharePoint permission management, Forms-Excel data flows, Teams meeting and channel operations, Power Automate and Power Apps automation, Copilot usage rules, and portfolio outputs.
Referenced professional training patterns
- Korean private digital-work competency courses using repeated Outlook, OneDrive, Word, Excel, and PowerPoint practice
- US/Canada productivity coaching courses using Microsoft 365 document collaboration, scheduling, and Teams-based asynchronous work patterns
- UK/European vocational Microsoft 365 onboarding, SharePoint team site, data management, and automation project patterns
- Copilot assistance, Power Automate workflows, Power Apps no-code apps, and SharePoint portfolio training-product outputs
Beginner · 1 Day
Beginner 1 Day Microsoft 365 Usage Curriculum
A one-day practical course for understanding Outlook, OneDrive, Word, Excel, PowerPoint, Teams, and OneNote, then applying them immediately to personal work and learning management.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Objective 1: Understand the basic structure and account environment of Microsoft 365. |
Learners distinguish Microsoft Account, organizational accounts, the Microsoft 365 app launcher, Outlook, OneDrive, Word, Excel, PowerPoint, Teams, and OneNote using real interface examples.
Learners check the differences between personal and work or school accounts, storage, sharing scope, sign-in security, multi-factor authentication, and OneDrive sync settings.
|
| Objective 2 | Objective 2: Handle basic email and scheduling tasks with Outlook and Calendar. |
Learners organize work email in Outlook using folders, categories, flags, search, rules, attachments, scheduled sending, signatures, and automatic replies.
Learners practice creating events, recurring schedules, attendee invitations, reminders, locations, Teams meeting links, and To Do deadlines in Outlook Calendar.
|
| Objective 3 | Objective 3: Learn basic OneDrive and collaborative document usage. |
Learners practice creating folders, uploading files, naming rules, favorites, sharing links, view-review-edit permissions, link expiration, and password settings in OneDrive.
Learners create a short collaborative report in Word Online using co-authoring, comments, review mode, track changes, version history, document sharing, and PDF export.
|
| Platforms | Microsoft Edge, Microsoft Account, Microsoft 365, Outlook, Outlook Calendar, OneDrive, Word Online, Microsoft Teams, Microsoft To Do, OneNote |
|---|---|
| Instructor profile | Instructor should have at least 2 years of Microsoft 365 digital work-tool training experience and be able to teach Outlook, OneDrive, Word, Teams, OneNote, repeated beginner practice, and account security basics. |
| Target learners | Students, college learners, job seekers, entry-level employees, general citizens, seniors, beginners in Microsoft tools, and learners who need online learning or work basics |
| Duration | 4-6 hours |
| Materials | Laptop or tablet, smartphone, internet, Microsoft account, Edge browser, practice email samples, scheduling scenario, and OneDrive sharing-permission checklist |
| Deliverables | Microsoft 365 app role map, Outlook organization rules, personal schedule, OneDrive folder structure, and Word collaborative document |
| Assessment | App-structure understanding 20%, Outlook and Calendar practice 25%, OneDrive organization 20%, Word collaboration 25%, participation 10% |
Beginner · 3 Days
Beginner 3 Days Microsoft 365 Usage Curriculum
A three-day course connecting Outlook, OneDrive, Word, Excel, PowerPoint, and Teams for personal productivity, collaboration, presentation creation, and meeting operations.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Objective 1: Create documents, spreadsheets, and presentations with Microsoft 365 tools. |
Learners create a report template in Word Online using heading styles, table of contents, comments, review tools, citations, tables, image insertion, and version history.
Learners build a work-management spreadsheet in Excel Online using data entry, filters, sorting, basic formulas, conditional formatting, charts, table formatting, and co-authoring permissions.
|
| Objective 2 | Objective 2: Operate team schedules, meetings, and file sharing around Teams. |
Learners connect Teams and Outlook Calendar to practice meeting invitations, attendee permissions, agenda document links, reminders, channel posts, and follow-up scheduling.
Learners design folder structures using OneDrive and SharePoint document libraries and create a checklist for view-review-edit permissions, external sharing restrictions, and link expiration.
|
| Objective 3 | Objective 3: Produce collaborative outputs with PowerPoint and Forms. |
Learners create a shared presentation in PowerPoint Online using themes, layouts, speaker notes, comments, version history, and sharing links.
Learners create satisfaction surveys, quizzes, application forms, and feedback forms in Microsoft Forms and connect responses to Excel for review.
|
| Platforms | Word Online, Excel Online, PowerPoint Online, Microsoft Forms, OneDrive, SharePoint, Outlook Calendar, Microsoft Teams, Outlook, Microsoft To Do, OneNote |
|---|---|
| Instructor profile | Instructor should have at least 3 years of training experience in Microsoft 365 documents, spreadsheets, presentations, and forms, plus collaboration, permission management, Teams meetings, and beginner feedback coaching. |
| Target learners | Student project teams, college learners, job seekers, new employees, freelancers, small teams, and learners who need online class or work collaboration |
| Duration | 12-18 hours |
| Materials | Laptop, smartphone, internet, Microsoft account, team project scenario, Word-Excel-PowerPoint templates, Forms question samples, and sharing-permission checklist |
| Deliverables | Collaborative report, Excel work-management file, Teams meeting schedule and agenda document, team OneDrive/SharePoint structure, presentation, and Microsoft Forms survey |
| Assessment | Document creation 20%, Excel management sheet 20%, schedule and meeting operation 20%, PowerPoint presentation 20%, Forms response management 10%, team feedback 10% |
Beginner · 1 Week
Beginner 1 Week Microsoft 365 Usage Curriculum
A one-week practical course expanding Microsoft 365 into self-directed learning management, work records, project collaboration, resource archives, and AI-assisted organization.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Objective 1: Build a personal and team work-management system with Microsoft 365. |
Learners connect Outlook, Calendar, Microsoft To Do, and OneNote to design routines for email capture, scheduling, task classification, quick notes, and notification checks.
Learners build a project tracker in Excel or Microsoft Lists for tasks, owners, status, deadlines, priorities, completion rates, and retrospectives.
|
| Objective 2 | Objective 2: Build a resource archive and knowledge-management structure. |
Learners build a resource archive in OneDrive and SharePoint using project folders, document templates, naming rules, version control, shortcuts, and metadata classification.
Learners create a team knowledge base in OneNote or SharePoint pages with meeting notes, FAQs, work manuals, reference links, and training materials.
|
| Objective 3 | Objective 3: Use Copilot and Microsoft 365 safely. |
Learners use Copilot or Microsoft Copilot web to create Word summaries, Excel table organization, Outlook email drafts, Teams meeting summaries, and PowerPoint outlines, then review them manually.
Learners define what personal, organizational, and assessment data must not be entered into AI tools, then write usage rules for checking factuality, copyright, and plagiarism risks.
|
| Platforms | Outlook, Outlook Calendar, Microsoft To Do, OneNote, OneDrive, SharePoint, Word, Excel, Microsoft Lists, Microsoft Teams, Microsoft Copilot, Microsoft 365 |
|---|---|
| Instructor profile | Instructor should have at least 3 years of Microsoft 365 work-management, knowledge-management, and AI-assistant training experience, plus OneDrive/SharePoint permission design and Copilot ethics guidance. |
| Target learners | Middle and high school project teams, college learners, entry-level employees, startup teams, education administrators, freelancers, and online project learners |
| Duration | 20-30 hours |
| Materials | Laptop, smartphone, internet, Microsoft account, Copilot-enabled environment, project resource samples, knowledge-base template, naming-rule sheet, and AI usage checklist |
| Deliverables | Microsoft 365 personal work-management system, project tracker, OneDrive/SharePoint resource archive, OneNote or SharePoint knowledge base, and Copilot usage log |
| Assessment | Personal and team management system 25%, project tracker 20%, resource archive 20%, knowledge base 15%, AI usage and security 20% |
Intermediate · 4 Weeks
Intermediate 4 Weeks Microsoft 365 Usage Curriculum
A four-week practical course expanding Microsoft 365 into team operations, collaboration rules, basic automation, data management, meeting operations, and collaboration performance tracking.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Objective 1: Design an organizational Microsoft 365 collaboration environment. |
Learners design SharePoint sites, Teams channels, OneDrive folder structures, sharing rules, access permissions, document templates, naming rules, and retention criteria by team, department, and project.
Learners practice Microsoft Entra ID concepts, Microsoft 365 Admin Center cases, security groups, external sharing, ownership transfer, and access revocation procedures when staff leave or move roles.
|
| Objective 2 | Objective 2: Build a data collection, analysis, and reporting flow. |
Learners create application forms, satisfaction surveys, attendance checks, and assessment forms in Microsoft Forms and connect responses to Excel or Microsoft Lists for automated aggregation.
Learners use XLOOKUP, FILTER, pivot tables, charts, data validation, and protected ranges in Excel, then visualize operations with Power BI or Excel dashboards.
|
| Objective 3 | Objective 3: Apply Microsoft 365 automation and meeting operations. |
Learners understand Power Automate basics and practice a scenario where Forms responses trigger Outlook notifications, Excel row additions, Planner task creation, and Teams channel alerts.
Learners connect Teams, Outlook Calendar, Word, PowerPoint, and OneNote to create an operations manual covering agendas, meeting notes, action items, follow-up schedules, and presentation outputs.
|
| Platforms | Microsoft 365 Admin Center cases, Microsoft Entra ID cases, SharePoint, Teams, OneDrive, Outlook, Microsoft Forms, Excel, Microsoft Lists, Power Automate, Outlook Calendar, Word, PowerPoint, OneNote, Power BI, Planner |
|---|---|
| Instructor profile | Instructor should have at least 4 years of Microsoft 365 team operations, data management, and automation training experience, and be able to teach SharePoint, Teams, permissions, Forms, Excel, Power Automate basics, and organizational operation-manual production. |
| Target learners | Employee upskilling learners, team leads, project managers, education administrators, HR and training managers, small-business teams, digital instructors, and beginner Microsoft 365 administrators |
| Duration | 40-60 hours |
| Materials | Laptop, internet, Microsoft 365 organization or practice account, administrator scenario, team project task list, Forms question samples, Excel data samples, Power Automate sample flows, and dashboard template |
| Deliverables | Organizational SharePoint/Teams structure, sharing-permission operation table, Forms-Excel data collection system, Excel or Power BI dashboard, Power Automate workflow example, and meeting operation manual |
| Assessment | Collaboration environment design 25%, permission management 20%, data collection and analysis 25%, automation example 15%, meeting operation manual 15% |
Advanced · 8 Weeks
Advanced 8 Weeks Microsoft 365 Usage Curriculum
An advanced project course connecting Microsoft 365 usage to organizational workflow consulting, training-product design, Power Automate and Power Apps automation, Copilot integration, and portfolio building.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Objective 1: Diagnose a Microsoft 365 work environment and design improvements. |
Learners select a fictional company, academy, education institution, nonprofit, or startup and diagnose issues in email, calendar, documents, OneDrive, SharePoint, Teams, data management, and permissions.
Learners write a diagnostic report based on information fragmentation, duplicate files, permission risks, repetitive manual work, meeting overload, unused data, and AI-use potential.
|
| Objective 2 | Objective 2: Complete a Microsoft 365 automation and app-building project. |
Learners implement basic Power Automate workflows such as automatic email sending, calendar creation, document template copying, Excel data organization, and Teams notifications.
Learners create one no-code work app in Power Apps for attendance, assignment submission, equipment rental, customer management, or training registration and connect it to Excel or Microsoft Lists.
|
| Objective 3 | Objective 3: Build a Microsoft 365 training product and portfolio. |
Learners design Microsoft 365 curricula for beginners, employees, instructors, administrators, and small businesses with session-level objectives, activities, and assessments.
Learners build a portfolio in SharePoint pages or a OneNote notebook integrating the diagnostic report, SharePoint design map, automation examples, Power Apps app, Copilot rules, training materials, and assessment rubrics.
|
| Platforms | Microsoft 365, Microsoft 365 Admin Center cases, Microsoft Entra ID cases, Outlook, OneDrive, SharePoint, Word, Excel, PowerPoint, Microsoft Forms, Outlook Calendar, Microsoft Teams, Power Automate, Power Apps, Microsoft Copilot, Power BI, Planner, OneNote |
|---|---|
| Instructor profile | Instructor should have at least 5 years of Microsoft 365 consulting, organizational workflow, Power Automate, Power Apps, and Copilot-assistant training experience and be able to run tool adoption strategy, training-product development, and portfolio-based projects. |
| Target learners | Digital instructor training learners, HR and training managers, team leads and administrators, education institution operators, startup teams, beginner workflow consultants, and internal Microsoft 365 trainers |
| Duration | 80-120 hours |
| Materials | Laptop, internet, Microsoft 365 practice account, Power Automate access, Power Apps account, Copilot-enabled environment, organizational diagnostic scenario, automation sample data, training-product design form, and portfolio template |
| Deliverables | Microsoft 365 diagnostic report, adoption and improvement strategy, Power Automate workflow scenario, Power Apps work app, target-specific curriculum plan, and SharePoint or OneNote portfolio |
| Assessment | Diagnostic report 25%, automation implementation 20%, Power Apps app 20%, training-product design 20%, portfolio presentation 15% |